<?php 
 
 include ("global_files/report_customization.inc"); 
 include ("global_files/tables.inc"); 

 $i=0; 
$columns_array1[$i]["filter_name"]="gsp_id";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(gsp_id)";
$columns_array1[$i]["form_display"]="Gsp id";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

// $columns_array1[$i]["filter_name"]="ship_date";
// $columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
// $columns_array1[$i]["form_field_name[1]"]="distinct(ship_date)";
// $columns_array1[$i]["form_display"]="Ship date";
// $columns_array1[$i]["fetch_condition"]="";
// $columns_array1[$i]["order_by"]="1";
// $i++;

$columns_array1[$i]["filter_name"]="zipcode_to";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(zipcode_to)";
$columns_array1[$i]["form_display"]="Zipcode to";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="country_to";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(country_to)";
$columns_array1[$i]["form_display"]="Country to";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="state_to";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(state_to)";
$columns_array1[$i]["form_display"]="State to";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="city_to";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(city_to)";
$columns_array1[$i]["form_display"]="City to";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="countryto";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(countryto)";
$columns_array1[$i]["form_display"]="Countryto";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="city_id_to";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(city_id_to)";
$columns_array1[$i]["form_display"]="City id to";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="address_to";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(address_to)";
$columns_array1[$i]["form_display"]="Address to";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="zipcode_from";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(zipcode_from)";
$columns_array1[$i]["form_display"]="Zipcode from";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="country_from";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(country_from)";
$columns_array1[$i]["form_display"]="Country from";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="state_from";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(state_from)";
$columns_array1[$i]["form_display"]="State from";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="city_from";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(city_from)";
$columns_array1[$i]["form_display"]="City from";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="countryfrom";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(countryfrom)";
$columns_array1[$i]["form_display"]="Countryfrom";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="city_id_from";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(city_id_from)";
$columns_array1[$i]["form_display"]="City id from";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="exp_address";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(exp_address)";
$columns_array1[$i]["form_display"]="Exp address";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="support_documents";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(support_documents)";
$columns_array1[$i]["form_display"]="Support documents";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="remarks";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(remarks)";
$columns_array1[$i]["form_display"]="Remarks";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="port_name";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(port_name)";
$columns_array1[$i]["form_display"]="Port name";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="shipment_mode_name";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(shipment_mode_name)";
$columns_array1[$i]["form_display"]="Shipment mode name";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="account_name";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(account_name)";
$columns_array1[$i]["form_display"]="Account name";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="buyer_name";
$columns_array1[$i]["filter_table_join"]="gsp_commercial_details_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(buyer_name)";
$columns_array1[$i]["form_display"]="Buyer name";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$db->query="begin work;";
$db->runQuery();
createNewFilters($columns_array1);
$db->query="commit work;";
$db->runQuery();

?>